-
Re: IS BLANK on INDEX and MATCH
Try this: =IFERROR(INDEX({1522 PC Items reference}, MATCH(Supplier@row, {1522LV PC Items Range 13}, 0), 0), "Not Found")1 · -
Re: 📢 Sticker Design Contest Winner Announced!
Congrats @Cherise White !1 · -
Re: IF OR statement with multiple ORs
I believe you are trying to say that if the first OR condition is true then calculate 0.1 times profit before commissions, else if commission structure is "Jr Est & Est Shared" then cal…1 · -
Re: NEW - Multi-Corner Dashboard Widget Resizing
Great improvement to widget resizing!1 · -
Re: Vlookup with contacts
Additionally, Make sure your range (lookup_table) includes all rows You can force the vlookup to search for exact match by adding FALSE as the last parameter1 ·